<Page id="1" templateExtension="html" relativePath="..\.." fullRelativePath=".\gharardad\user_part" secured="False" urlType="Relative" isIncluded="False" SSLAccess="False" wizardTheme="Clear" wizardThemeType="File" needGeneration="0">
	<Components>
		<Grid id="2" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="199" connection="projectkar" dataSource="SELECT CONTRACT.*,PROJECT.NAME project_name,CONTRACT_SITUATION.&quot;DATE&quot;
FROM CONTRACT,PROJECT,CONTRACT_SITUATION where
  (select project.use_id from project  
  where project.id=CONTRACT.pro_id)={CUSTOMER_ID}
AND
  CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID
AND 
  CONTRACT_SITUATION.ID=
             (SELECT max(CONTRACT_SITUATION.ID)
              FROM CONTRACT_SITUATION 
              where CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID)
AND 
  (select situations_def_sc.text
  from situations_def_sc
  where contract_situation.situation=situations_def_sc.code)='BEFORE_TERMINATION'
AND
  CONTRACT.PRO_ID=PROJECT.ID  ;" name="choice_before_termination_contracts" pageSizeLimit="199" wizardCaption="List of CONTRACT, PROJECT " wizardTheme="Clear" wizardThemeType="File" wizardGridType="Tabular" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="False" parameterTypeListName="ParameterTypeList" activeCollection="SQLParameters">
			<Components>
				<Label id="9" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="CONTRACT_NAME" fieldSource="NAME" wizardCaption="CONTRACT NAME" wizardTheme="Clear" wizardThemeType="File" wizardSize="50" wizardMaxLength="80" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="10" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="PROJECT_NAME" fieldSource="PROJECT_NAME" wizardCaption="PROJECT NAME" wizardTheme="Clear" wizardThemeType="File" wizardSize="20" wizardMaxLength="20" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="11" fieldSourceType="DBColumn" dataType="Date" html="False" editable="False" name="DATE" fieldSource="DATE" wizardCaption="DATE" wizardTheme="Clear" wizardThemeType="File" wizardSize="10" wizardMaxLength="26" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Link id="37" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="Link1" wizardTheme="Clear" wizardThemeType="File">
					<Components/>
					<Events/>
					<LinkParameters/>
				</Link>
				<Link id="38" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="Link2" wizardTheme="Clear" wizardThemeType="File">
					<Components/>
					<Events/>
					<LinkParameters/>
				</Link>
			</Components>
			<Events/>
			<TableParameters/>
			<JoinTables>
				<JoinTable id="3" tableName="CONTRACT" posWidth="100" posHeight="204" posLeft="10" posTop="10"/>
				<JoinTable id="5" tableName="PROJECT" posWidth="100" posHeight="212" posLeft="248" posTop="17"/>
			</JoinTables>
			<JoinLinks>
				<JoinTable2 id="8" fieldLeft="CONTRACT.PRO_ID" fieldRight="PROJECT.ID" tableLeft="CONTRACT" tableRight="PROJECT" conditionType="Equal" joinType="inner"/>
			</JoinLinks>
			<Fields>
				<Field id="4" tableName="CONTRACT" alias="CONTRACT_NAME" fieldName="CONTRACT.NAME"/>
				<Field id="6" tableName="PROJECT" alias="PROJECT_NAME" fieldName="PROJECT.NAME"/>
				<Field id="7" tableName="PROJECT" fieldName="DATE"/>
			</Fields>
			<SPParameters/>
			<SQLParameters>
				<SQLParameter id="32" variable="CUSTOMER_ID" parameterType="Session" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="USER_ID"/>
			</SQLParameters>
			<SecurityGroups/>
		</Grid>
		<Grid id="12" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="100" connection="projectkar" dataSource="SELECT CONTRACT.*,PROJECT.NAME project_name,CONTRACT_SITUATION.&quot;DATE&quot;
FROM CONTRACT,PROJECT,CONTRACT_SITUATION where
  (select project.use_id from project  
  where project.id=CONTRACT.pro_id)={CUSTOMER_ID}
AND
  CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID
AND 
  CONTRACT_SITUATION.ID=
             (SELECT max(CONTRACT_SITUATION.ID)
              FROM CONTRACT_SITUATION 
              where CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID)
AND 
  (select situations_def_sc.text
  from situations_def_sc
  where contract_situation.situation=situations_def_sc.code)='ON_REBUILD_SITUATION'
AND
  CONTRACT.PRO_ID=PROJECT.ID;" name="choice_rebuild_situation_contracts" pageSizeLimit="100" wizardCaption="List of CONTRACT, PROJECT " wizardTheme="Clear" wizardThemeType="File" wizardGridType="Tabular" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="False" parameterTypeListName="ParameterTypeList" activeCollection="SQLParameters">
			<Components>
				<Label id="19" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="CONTRACT_NAME" fieldSource="NAME" wizardCaption="CONTRACT NAME" wizardTheme="Clear" wizardThemeType="File" wizardSize="50" wizardMaxLength="80" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="20" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="PROJECT_NAME" fieldSource="PROJECT_NAME" wizardCaption="PROJECT NAME" wizardTheme="Clear" wizardThemeType="File" wizardSize="20" wizardMaxLength="20" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="21" fieldSourceType="DBColumn" dataType="Date" html="False" editable="False" name="DATE" fieldSource="DATE" wizardCaption="DATE" wizardTheme="Clear" wizardThemeType="File" wizardSize="10" wizardMaxLength="26" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Link id="35" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="Link1" wizardTheme="Clear" wizardThemeType="File">
					<Components/>
					<Events/>
					<LinkParameters/>
				</Link>
				<Link id="36" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="Link2" wizardTheme="Clear" wizardThemeType="File">
					<Components/>
					<Events/>
					<LinkParameters/>
				</Link>
			</Components>
			<Events/>
			<TableParameters/>
			<JoinTables>
				<JoinTable id="13" tableName="CONTRACT" posWidth="100" posHeight="215" posLeft="10" posTop="10"/>
				<JoinTable id="15" tableName="PROJECT" posWidth="170" posHeight="235" posLeft="236" posTop="-1"/>
			</JoinTables>
			<JoinLinks>
				<JoinTable2 id="18" fieldLeft="CONTRACT.PRO_ID" fieldRight="PROJECT.ID" tableLeft="CONTRACT" tableRight="PROJECT" conditionType="Equal" joinType="inner"/>
			</JoinLinks>
			<Fields>
				<Field id="14" tableName="CONTRACT" alias="CONTRACT_NAME" fieldName="CONTRACT.NAME"/>
				<Field id="16" tableName="PROJECT" alias="PROJECT_NAME" fieldName="PROJECT.NAME"/>
				<Field id="17" tableName="PROJECT" fieldName="DATE"/>
			</Fields>
			<SPParameters/>
			<SQLParameters>
				<SQLParameter id="33" variable="CUSTOMER_ID" parameterType="Session" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="USER_ID"/>
			</SQLParameters>
			<SecurityGroups/>
		</Grid>
		<Grid id="22" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="199" connection="projectkar" dataSource="SELECT CONTRACT.*,PROJECT.NAME project_name,CONTRACT_SITUATION.&quot;DATE&quot;
FROM CONTRACT,PROJECT,CONTRACT_SITUATION 
where
 (CONTRACT.pro_id=project.id AND project.use_id={CUSTOMER_ID})
AND
  CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID
AND 
  CONTRACT_SITUATION.ID=
             (SELECT max(CONTRACT_SITUATION.ID)
              FROM CONTRACT_SITUATION 
              where CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID)
AND
(select text from SITUATIONS_DEF_SC
   where code=
   (SELECT CONTRACT_SITUATION.SITUATION
    FROM CONTRACT_SITUATION 
    where CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID
          and CONTRACT_SITUATION.ID=
             (SELECT max(CONTRACT_SITUATION.ID)-1
              FROM CONTRACT_SITUATION 
              where CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID))
  )='ON_MANAGER_OPINION'
AND 
  (select situations_def_sc.text
  from situations_def_sc
  where contract_situation.situation=situations_def_sc.code)='TERMINATED'
AND
  CONTRACT.PRO_ID=PROJECT.ID;" name="notify_on_manager_opinion_project_ok_contracts" pageSizeLimit="199" wizardCaption="List of CONTRACT, PROJECT " wizardTheme="Clear" wizardThemeType="File" wizardGridType="Tabular" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="False" parameterTypeListName="ParameterTypeList" activeCollection="SQLParameters">
			<Components>
				<Label id="29" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="CONTRACT_NAME" fieldSource="NAME" wizardCaption="CONTRACT NAME" wizardTheme="Clear" wizardThemeType="File" wizardSize="50" wizardMaxLength="80" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="31" fieldSourceType="DBColumn" dataType="Date" html="False" editable="False" name="DATE" fieldSource="DATE" wizardCaption="DATE" wizardTheme="Clear" wizardThemeType="File" wizardSize="10" wizardMaxLength="26" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="30" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="PROJECT_NAME" fieldSource="PROJECT_NAME" wizardCaption="PROJECT NAME" wizardTheme="Clear" wizardThemeType="File" wizardSize="20" wizardMaxLength="20" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
			</Components>
			<Events/>
			<TableParameters/>
			<JoinTables>
				<JoinTable id="23" tableName="CONTRACT" posWidth="100" posHeight="203" posLeft="22" posTop="26"/>
				<JoinTable id="25" tableName="PROJECT" posWidth="100" posHeight="234" posLeft="240" posTop="31"/>
			</JoinTables>
			<JoinLinks>
				<JoinTable2 id="28" fieldLeft="CONTRACT.PRO_ID" fieldRight="PROJECT.ID" tableLeft="CONTRACT" tableRight="PROJECT" conditionType="Equal" joinType="inner"/>
			</JoinLinks>
			<Fields>
				<Field id="24" tableName="CONTRACT" alias="CONTRACT_NAME" fieldName="CONTRACT.NAME"/>
				<Field id="26" tableName="PROJECT" alias="PROJECT_NAME" fieldName="PROJECT.NAME"/>
				<Field id="27" tableName="PROJECT" fieldName="DATE"/>
			</Fields>
			<SPParameters/>
			<SQLParameters>
				<SQLParameter id="34" variable="CUSTOMER_ID" parameterType="Session" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="USER_ID"/>
			</SQLParameters>
			<SecurityGroups/>
		</Grid>
	</Components>
	<CodeFiles>
		<CodeFile id="Model" language="JSP" name="user_choosing_and_notifires.xml" path="." comment="&lt;!--" commentEnd="--&gt;" codePage="iso-8859-1" forShow="False"/>
		<CodeFile id="JSP" language="JSP" name="user_choosing_and_notifires.jsp" path="." comment="&lt;%--" commentEnd="--%&gt;" codePage="iso-8859-1" forShow="True" url="user_choosing_and_notifires.jsp"/>
		<CodeFile id="Handlers" language="JSP" name="user_choosing_and_notifiresHandlers.jsp" path="." comment="//" codePage="iso-8859-1" forShow="False"/>
	</CodeFiles>
	<SecurityGroups/>
	<Events/>
</Page>
